﻿CREATE TYPE [flcr].[DEVICE_CATEGORY_UDT] AS  TABLE (
    [DEVICE_CATEGORY_ID] INT           NULL,
    [AUDIT_USER]         VARCHAR (50)  NULL,
    [AUDIT_DTTM]         DATETIME      NULL,
    [AUDIT_DTTM_TZ]      INT           NULL,
    [AUDIT_MOD_USER]     VARCHAR (50)  NULL,
    [AUDIT_MOD_DTTM]     DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ]  INT           NULL,
    [BUILTIN]            BIT           NULL,
    [ACTIVE_FLG]         BIT           NULL,
    [SORT_ORDER]         INT           NULL,
    [DEVICE_CAT_NAME]    VARCHAR (100) NULL,
    [DEVICE_CAT_DESC]    VARCHAR (250) NULL);

